SELECT 
    BusinessEntityID, 
    Rate,   
    RANK() OVER (ORDER BY Rate DESC) AS RankBySalary  
FROM 
    HumanResources.EmployeePayHistory AS eph1  
WHERE 
    RateChangeDate = (
        SELECT MAX(RateChangeDate)   
        FROM HumanResources.EmployeePayHistory AS eph2  
        WHERE eph1.BusinessEntityID = eph2.BusinessEntityID
    )  
ORDER BY 
    BusinessEntityID
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;


